Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | |
RentalDepositAmount | A deposit amount paid by the customer as part of setting up a rental account. The RentalDepositAmount is typically used to offset the total rent due upon return of the rented item. | MO_RNT_DS_AMT | Money | decimal(16,5) | |
RentalPeriodStartDateTime | The date and time a rental period begins. For some items (e.g. suba gear, specialty auto tools, etc.) a rental period may be hours and minutes. For other kinds of rented items the period might be days or weeks. | DT_RNT_PRD_SRT_DT_TM | DateTime | datetime | |
LateReturnFeePerPeriodAmount | The late fee charged per rental period when an item is returned late. | MO_LT_RTN_FE_PR_PRD_AMT | Money | decimal(16,5) | |
MinimumLateReturnFeeAmount | A minimum flat late return fee. | MO_MNM_LT_RTN_FE_AMT | Money | decimal(16,5) | |